package com.apes.fa.respository;

import com.apes.fa.model.FaAssetInvestItem;
import com.apes.framework.jpa.repository.CustomRepository;
import org.springframework.data.jpa.repository.Query;

import java.util.List;

public interface FaAssetInvestItemRepository extends CustomRepository<FaAssetInvestItem,String> {

    @Query(value = "" +
            " SELECT " +
            " f.*" +
            " FROM " +
            " fa_asset_invest_item f" +
            " WHERE " +
            " f.fa_card_id = :id"
            ,nativeQuery = true)
    List<FaAssetInvestItem> findCard(String id);
}
